145ce9ce65819ee14348bccbc376bb7f3c5e2b99,portal-impl/src/com/liferay/portal/upgrade/v6_1_0/UpgradeJournal.java,UpgradeJournal,doUpgrade,#,31

Before Change



	@Override
	protected void doUpgrade() throws Exception {
		try {
			runSQL("alter_column_type JournalArticle title STRING null");
		}
		catch (Exception e) {
			UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
				JournalArticleTable.TABLE_NAME,
				JournalArticleTable.TABLE_COLUMNS);

			upgradeTable.setCreateSQL(JournalArticleTable.TABLE_SQL_CREATE);
			upgradeTable.setIndexesSQL(
				JournalArticleTable.TABLE_SQL_ADD_INDEXES);

			upgradeTable.updateTable();
		}

		try {
			runSQL("alter_column_type JournalStructure name STRING null");
			runSQL(
				"alter_column_type JournalStructure description STRING null");
		}
		catch (Exception e) {
			UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
				JournalStructureTable.TABLE_NAME,
				JournalStructureTable.TABLE_COLUMNS);

			upgradeTable.setCreateSQL(JournalStructureTable.TABLE_SQL_CREATE);
			upgradeTable.setIndexesSQL(
				JournalStructureTable.TABLE_SQL_ADD_INDEXES);

			upgradeTable.updateTable();
		}

		try {
			runSQL("alter_column_type JournalTemplate name STRING null");
			runSQL("alter_column_type JournalTemplate description STRING null");
		}
		catch (Exception e) {
			UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
				JournalTemplateTable.TABLE_NAME,
				JournalTemplateTable.TABLE_COLUMNS);

			upgradeTable.setCreateSQL(JournalTemplateTable.TABLE_SQL_CREATE);
			upgradeTable.setIndexesSQL(
				JournalTemplateTable.TABLE_SQL_ADD_INDEXES);

			upgradeTable.updateTable();
		}

		updateStructureXsd();

After Change



	@Override
	protected void doUpgrade() throws Exception {
		if (isSupportsAlterColumnType()) {
			runSQL("alter_column_type JournalArticle title STRING null");

			runSQL("alter_column_type JournalStructure name STRING null");
			runSQL(
				"alter_column_type JournalStructure description STRING null");

			runSQL("alter_column_type JournalTemplate name STRING null");
			runSQL("alter_column_type JournalTemplate description STRING null");
		}
		else {
			UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
				JournalArticleTable.TABLE_NAME,
				JournalArticleTable.TABLE_COLUMNS);

			upgradeTable.setCreateSQL(JournalArticleTable.TABLE_SQL_CREATE);
			upgradeTable.setIndexesSQL(
				JournalArticleTable.TABLE_SQL_ADD_INDEXES);

			upgradeTable.updateTable();

			upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
				JournalStructureTable.TABLE_NAME,
				JournalStructureTable.TABLE_COLUMNS);

			upgradeTable.setCreateSQL(JournalStructureTable.TABLE_SQL_CREATE);
			upgradeTable.setIndexesSQL(
				JournalStructureTable.TABLE_SQL_ADD_INDEXES);

			upgradeTable.updateTable();

			upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
				JournalTemplateTable.TABLE_NAME,
				JournalTemplateTable.TABLE_COLUMNS);

			upgradeTable.setCreateSQL(JournalTemplateTable.TABLE_SQL_CREATE);
			upgradeTable.setIndexesSQL(
				JournalTemplateTable.TABLE_SQL_ADD_INDEXES);

			upgradeTable.updateTable();
		}

		updateStructureXsd();